home *** CD-ROM | disk | FTP | other *** search
/ Software of the Month Club 1996 May / Software of the Month Club 1996 May.iso / mac / ISO9660 / OS2 / MESA / EXAMPLES / ACCOUNT.M2 next >
Encoding:
Text File  |  1995-10-10  |  85.0 KB  |  433 lines  |  [TEXT/hscd]
  1. Mesa2DPP#G╚
  2. 
  3. _╙ÇZⁿ   √   êd        ÇÇ
  4. Script  1        ÇÇ
  5. Script  2                                                                                                                            ∞
  6. Helv⌠≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡? Ω       └└└╠╠╠└└└Cover HkkL╖½¬J    #5Åí┼
  7. ╪ √
  8. ¥?ε â
  9.    └└└╠╠╠└└└    Checking HmmJ╖úΩ0%     └└└╠╠╠└└└Savings Hi▒á& ┤ applepÇCATpÇCheckingBalancepÇDOGpÇSavingsBalance pÇ┐!
  10. Script  1φ/* The purpose of this MScript is to move the     */
  11. /* entry on the Cover Page into either the     */
  12. /* checking or savings account based on the     */
  13. /* Transaction Type Specified by the user.    */
  14.  
  15. /* Create the variables we will use.         */
  16. counter:    /* For finding the right row.      */
  17. searchvalue:    /* For finding the right row.      */
  18. layer:        /* Which layer are we on.    */
  19. transactiontype:
  20. withdrawal:    /* 1 if a withdrawal, 0 if not    */
  21. deposit:        /* 1 if a deposit, 0 if not    */
  22. transfer:    /* 1 if a transfer, 0 if not    */
  23.  
  24. /* Set counter to row 9.             */
  25. counter = 9
  26.  
  27. /* Initialize all of the other variables to 0.     */
  28. searchvalue = 0
  29. layer = 0
  30. transactiontype = 0
  31. withdrawal = 0
  32. deposit = 0
  33. transfer = 0
  34. test = 0
  35.  
  36. /* Get the Transaction Type.            */
  37. transactiontype = getc("[Cover]a21")
  38.  
  39. /* Determine what action to take based on     */
  40. /* the Transaction Type.             */
  41.  
  42. /* Remember to put the ' character before    */
  43. /* all of the text we will import as Mesa 2     */
  44. /* inserts horizontal alignment characters    */
  45. /* ALA 123.                    */
  46. IF transactiontype = "'ATM" THEN DO
  47.    layer = 2
  48.    withdrawal = 1
  49. END 
  50. ELSE IF transactiontype = "'CDeposit" THEN DO
  51.    layer = 2
  52.    deposit = 1
  53. END 
  54. ELSE IF transactiontype = "'SDeposit" THEN DO
  55.    layer = 3
  56.    deposit = 1
  57. END 
  58. ELSE IF transactiontype = "'Interest" THEN DO
  59.    layer = 3
  60.    deposit = 1
  61. END 
  62. ELSE IF transactiontype = "'Transfer" THEN DO
  63.    layer = 2
  64.    transfer = 1
  65. END 
  66. /* Everything else failed, assume it is a     */
  67. /* check with a number in the Transaction     */
  68. /* Type field.     */
  69. ELSE DO 
  70.    layer = 2
  71.    withdrawal = 1
  72. END
  73.  
  74. /* Select the Layer, this is not needed, it just    */
  75. /* makes things look better.            */
  76. Sel(cell(1,1,layer))
  77.  
  78. /* Find the last line of the data.         */
  79. DO FOREVER,
  80.    UNTIL searchvalue = ""
  81.    searchvalue = getc(cell(counter,1,layer))
  82.    counter = counter + 1
  83. END
  84.  
  85. /* Move the Total line down by one row.     */
  86. Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  87. copy()
  88. Sel(cell(counter+1,1,layer))
  89. paste()
  90. Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  91. clear()
  92.  
  93. /* Set the labeled range to the new line so we    */
  94. /* can get the latest balance automatically.        */
  95. IF layer = 2 THEN DO
  96.    SetLabel("CheckingBalance",cell(counter+1,7,layer))
  97. END
  98. ELSE DO
  99.    SetLabel("SavingsBalance",cell(counter+1,7,layer))
  100. END
  101.  
  102. /* Select Cover Layer this is not needed, it     */
  103. /* just makes things look better.        */
  104. Sel("[Cover]A1")
  105.  
  106. /* Copy the first 3 cells to the correct entry.     */
  107. Sel("[Cover]a21:[Cover]c21")
  108. copy()
  109. Sel(cell(counter-1,1,layer))
  110. paste("Values")
  111.  
  112. /* Make sure the second cell is Date Formatted.    */
  113. Sel(cell(counter-1,2,layer))
  114. SetFormat("MM/DD/YY")
  115.  
  116. /* Get the value of the transaction.         */
  117. value = getc("[Cover]d21")
  118.  
  119. /* Select the Layer, this is not needed, it just    */
  120. /* makes things look better.            */
  121. Sel(cell(1,1,layer))
  122.  
  123. /* Copy the value into the correct entry.     */
  124. IF withdrawal = 1 THEN DO
  125.    putc(value,cell(counter-1,5,layer))
  126.  
  127. /* Format the right cells.             */
  128.    Sel(cell(counter-1,5,layer))
  129.    SetFormat("currency1","2")
  130.    Sel("[Checking]f10:[Checking]g10")
  131.    copy()
  132.    Sel(cell(counter-1,6,layer))
  133.    paste()
  134.  
  135. /* Set deposit back to 0.             */
  136.    withdrawal = 0
  137. END
  138. ELSE IF deposit = 1 THEN DO
  139.    putc(value,cell(counter-1,4,layer))
  140.  
  141. /* Format the right cells.             */
  142.    Sel(cell(counter-1,4,layer))
  143.    SetFormat("currency1","2")
  144.    Sel("[Checking]f10:[Checking]g10")
  145.    copy()
  146.    Sel(cell(counter-1,6,layer))
  147.    paste()
  148.  
  149. /* Set deposit back to 0.             */
  150.    deposit = 0
  151. END
  152. /* If it isn't a withdrawal or a deposit then it    */
  153. /* is a transfer.                    */
  154. ELSE DO
  155.    putc(value,cell(counter-1,5,layer))
  156.  
  157. /* Format the right cells.             */
  158.    Sel(cell(counter-1,5,layer))
  159.    SetFormat("currency1","2")
  160.    Sel("[Checking]f10:[Checking]g10")
  161.    copy()
  162.    Sel(cell(counter-1,6,layer))
  163.    paste()
  164.  
  165. /* Set the following values so we can change    */
  166. /* the savings layer.                */
  167.    layer = 3
  168.    counter = 9
  169.    searchvalue = 0
  170.  
  171. /* Find the last line of the data of the savings */
  172. /* layer                     */
  173.       DO FOREVER,
  174.        UNTIL searchvalue = ""
  175.        searchvalue = getc(cell(counter,1,layer))
  176.        counter = counter + 1
  177.       END
  178.  
  179. /* Move the Savings Total line down by one     */
  180. /* row.                     */
  181.    Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  182.    copy()
  183.    Sel(cell(counter+1,1,layer))
  184.    paste()
  185.    Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  186.    clear()
  187.  
  188. /* Set the labeled range to the new line so we */
  189. /* can get the latest balance automatically.    */
  190.    SetLabel("SavingsBalance",cell(counter+1,7,layer))
  191.  
  192. /* Copy the first 3 cells to the correct entry.     */
  193.    Sel("[Cover]a21:[Cover]c21")
  194.    copy()
  195.    Sel(cell(counter-1,1,layer))
  196.    paste("Values")
  197.  
  198. /* Make sure the second cell is Date Formatted.    */
  199.    Sel(cell(counter-1,2,layer))
  200.    SetFormat("MM/DD/YY")
  201.  
  202. /* Copy the value into the correct entry.     */
  203.    putc(value,cell(counter-1,4,layer))
  204.  
  205. /* Format the right cells.             */
  206.    Sel(cell(counter-1,4,layer))
  207.    SetFormat("currency1","2")
  208.    Sel("[Checking]f10:[Checking]g10")
  209.    copy()
  210.    Sel(cell(counter-1,6,layer))
  211.    paste()
  212.  
  213. /* Set transfer back to 0.             */
  214.    transfer = 0
  215. END
  216.  
  217. /* We are done updating everything.  Now go    */
  218. /* reset the row 21 of the Cover Page so we     */
  219. /* can do this again.                */
  220. Sel("[Cover]a21:[Cover]d21")
  221. clear("Values")
  222.  
  223. /* And go set all of the variables back to     */
  224. /* what we started with.            */
  225. counter = 0
  226. searchvalue = 0
  227. layer = 0
  228. transactiontype = 0
  229. withdrawal = 0
  230. desposit = 0
  231. transfer = 0
  232.  
  233. `"
  234. Script  2â/* Reset script so I can reset the labeled ranges     */
  235. SetLabel("CheckingBalance","[b]g20")
  236. SetLabel("SavingsBalance","[c]g13")
  237. -#dHHHH Helv Helv Helv Helv Helv Helv Helv Helvq#   d   └└└└└└@╡#   d   └└└└└└@∙#   d   └└└└└└@=$   d   └└└└└└@ü$   d   └└└└└└@┼$   d   └└└└└└@    %   d   └└└└└└@M%   d   └└└└└└
  238. @æ%   d   └└└└└└
  239. @╒%   d   └└└└└└@&   d   └└└└└└
  240. @]&   d   └└└└└└    @í&   d   └└└└└└    @σ&   d   └└└└└└    @)'   d   └└└└└└@m'    d   └└└└└└@▒' d   └└└└└└⌡'   d   └└└└└└9(╨╨╨d   └└└└└└}(ÇÇd   └└└└└└┴( Çd   └└└└└└)   d   └└└└└└I)Çd   └└└└└└ì)Ç   d   └└└└└└╤)    d   └└└└└└@*Ç   d   └└└└└└@Y*   d   └└└└└└@¥*   d   └└└└└└@ß* d   └└└└└└%+ d   └└└└└└
  241. i+ d   └└└└└└¡+ d   └└└└└└±+ÇÇÇd   └└└└└└5,ÇÇÇd   └└└└└└
  242. y,ÇÇÇd   └└└└└└╜,ÇÇÇd   └└└└└└- d   └└└└└└E-  d   └└└└└└ë-  d   └└└└└└
  243. ═-  d   └└└└└└.  d   └└└└└└U. d   └└└└└└Ö.Ç d   └└└└└└▌. d   └└└└└└!/ÇÇÇÇd   └└└└└└e/    d   └└└└└└@⌐/  d   └└└└└└φ/  d   └└└└└└
  244. 10  d   └└└└└└u0  d   └└└└└└╣0  d   └└└└└└²0  d   └└└└└└A1 d   └└└└└└à1    d   └└└└└└@╔1    d   └└└└└└@
  245. 2   d   └└└└└└
  246. Q2   d   └└└└└└
  247. @ò2   d   └└└└└└    ┘2   d   └└└└└└    @3   d   └└└└└└@a3   d   └└└└└└@Ñ3    d   └└└└└└    @Θ3    d   └└└└└└    D-4   d   └└└└└└@q4ÇÇÇd   └└└└└└╡4ÇÇÇd   └└└└└└    ∙4 ÇÇÇd   └└└└└└=5 ÇÇÇd   └└└└└└    ü5 ÇÇÇd   └└└└└└┼5   ÇÇÇd   └└└└└└    6   ÇÇÇd   └└└└└└    M6   ÇÇÇd   └└└└└└æ6└└└d   └└└└└└╒6└└└d   └└└└└└    7└└└d   └└└└└└]7└└└d   └└└└└└í7└└└d   └└└└└└σ7└└└d   └└└└└└    )8 └└└d   └└└└└└    m8└└└d   └└└└└└▒8└└└d   └└└└└└
  248. ⌡8ÇÇÇd   └└└└└└99ÇÇÇd   └└└└└└    }9ÇÇÇd   └└└└└└┴9   ÇÇÇd   └└└└└└:   ÇÇÇd   └└└└└└    I:   ÇÇÇd   └└└└└└ì: └└└d   └└└└└└╤:Ç└└└d   └└└└└└;└└└d   └└└└└└Y;   d   └└└└└└@¥;   d   └└└└└└    @ß;└└└d   └└└└└└%<└└└d   └└└└└└    i<└└└└└└└└└¡<└└└└└└└└└    ±<└└└└└└5=└└└└└└    y=└└└U╜=└└└U    >└└└TE>└└└T    ë>└└└Y═>└└└X    ?└└└XU?└└└ÖÖ?└└└ÿ    ▌?└└└ÿ!@└└└⌐e@└└└¿    ⌐@└└└¿φ@└└└¬1A└└└d   └└└└└└    uA└└└¿    ╣A└└└d   └└└└└└    ²A└└└d   └└└└└└ AB└└└d   └└└└└└àB└└└ó╔B└└└á    
  249. C└└└áQC└└└ó    òC└└└ó┘C└└└d   └└└└└└
  250. D   d   └└└└└└@aD   d   └└└└└└    @ÑD   d   └└└└└└@ΘD└└└d   └└└└└└
  251.     -E   d   └└└└└└
  252.     @qE   d   └└└└└└
  253.     ╡E   d   └└└└└└
  254.     @∙E   d   └└└└└└
  255. @=F└└└d   └└└└└└    üF   d   └└└└└└    ┼F   d   └└└└└└    @    G   d   └└└└└└@MG└└└d   └└└└└└
  256. æG   d   └└└└└└
  257. @╒G   d   └└└└└└
  258. H   d   └└└└└└
  259. @]H   d   └└└└└└
  260. 
  261. @íH   d   └└└└└└
  262. @σH└└└ó    )I   ÇÇÇd   └└└└└└mI   ÇÇÇd   └└└└└└    ▒I└└└d   └└└└└└⌡I└└└d   └└└└└└    9JÇÇÇd   └└└└└└}J└└└ó┴J└└└ó    K└└└óIK└└└d   └└└└└└ìK └└└d   └└└└└└    ╤KÇÇÇd   └└└└└└    L└└└d   └└└└└└
  263. YL└└└d   └└└└└└
  264. ¥L   ÇÇÇd   └└└└└└    ßL└└└d   └└└└└└%M└└└d   └└└└└└    iM└└└ó¡M└└└ó    ±M└└└ó5N└└└d   └└└└└└yN └└└d   └└└└└└    ╜NÇÇÇd   └└└└└└    O└└└d   └└└└└└
  265. EO└└└d   └└└└└└
  266. ëO   ÇÇÇd   └└└└└└═O └└└d   └└└└└└P└└└d   └└└└└└
  267. UP   d   └└└└└└
  268. @ÖP   d   └└└└└└▌P   d   └└└└└└
  269. !Q   d   └└└└└└    @eQ   d   └└└└└└@⌐Q   d   └└└└└└@φQ   d   └└└└└└@1RÇ└└└d   └└└└└└uR└└└d   └└└└└└╣R   d   └└└└└└    @²R└└└d   └└└└└└    AS└└└d   └└└└└└àS   d   └└└└└└    @╔S   d   └└└└└└@
  270. T   d   └└└└└└QT   d   └└└└└└
  271. @òT   d   └└└└└└@┘T╠╠╠d   └└└└└└U╠╠╠d   └└└└└└    aU╠╠╠d   └└└└└└ÑU╠╠╠óΘU╠╠╠ó    -V╠╠╠óqV╠╠╠d   └└└└└└╡V ╠╠╠d   └└└└└└    ∙V╠╠╠d   └└└└└└
  272. =W╠╠╠d   └└└└└└
  273. üW ╠╠╠d   └└└└└└┼W╠╠╠d   └└└└└└
  274.     XÇ╠╠╠d   └└└└└└MX╠╠╠d   └└└└└└bX HelvX
  275. Tms Rmn Bold₧XHelvetica Bold╜X Helvetica Bold╫X
  276. Helvetica÷XHelvetica BoldYHelvetica Bold9YTms Rmn Bold Italic^YTimes New Roman BoldsYHelv    b[dz╝    Graph  1
  277. Script  1Ç @ ÇÇÇÇÇÇÇÇÇÇÇÇ╠╠╠            ≡wwwwwwwwwwpêêêêêêêêêêpêêêéêéêêêêpêêêéêéêêêêpêêê"""(êêêpêêé""""êêêpêê"éêéé(êêpêê(éêéê(êêpêêêéêéê(êêpêêêéêéé(êêpêêê""""êêêpêêé"""(êêêpêê"éêéêêêêpêê(éêéêêêêpêê(éêéê(êêpêê"éêéé(êêpêêé""""êêêpêêê"""(êêêpêêêéêéêêêêpêêêéêéêêêêpêêêêêêêêêêp          ≡≡
  278. ╡[.,$.,Ñ.,ú,.·[ÇE        $$Checking and Savings Account Example\Å        :\~Ä        Z\~Ä        z\~Ä        Ü\~Ä        ║\~║        ┌\~║        ·\~║        ]    ║        :]
  279. ║        Z] ║        z] ║        Ü]
  280. ║        ║]║        ┌]H        ·]║        ^~╗        :^~║        Z^~║        z^~║        Ü^~║        ║^║        ┌^║        ·^║        _    ║        :_
  281. ║        Z_ ║        z_ ║        Ü_
  282. ║        ║_║        ┌_H        N`Ç║        SSThis workbook demonstrates how you can use MScript to create a Checking and Savingsn`~╗        Ä`~║        «`~║        ╬`~║        ε`~║        a║        .a║        Na║        na    ║        Äa
  283. ║        «a ║        ╬a ║        εa
  284. ║        b║        .bH        ªbÇ║        WWaccount in Mesa 2.  The Cover Page allows you to enter in a new entry and see a summary╞b~╗        µb~║        c~║        &c~║        Fc~║        fc║        åc║        ªc║        ╞c    ║        µc
  285. ║        d ║        &d ║        Fd
  286. ║        fd║        ådH        eÇ║        aaof the balances of both accounts.  To enter a new entry into the account, fill in the information(e~╗        He~║        he~║        êe~║        ¿e~║        ╚e║        Φe║        f║        (f    ║        Hf
  287. ║        hf ║        êf ║        ¿f
  288. ║        ╚f║        ΦfH        fgÇ║        ]]in the fields below and double click the abacus icon to enter the new entry.  The script willåg~╗        ªg~║        ╞g~║        µg~║        h~║        &h║        Fh║        fh║        åh    ║        ªh
  289. ║        ╞h ║        µh ║        i
  290. ║        &i║        FiH        ╞iÇ║        __check the transaction type field to see if it matches one of the types it knows of.  The scriptµi~╗        j~║        &j~║        Fj~║        fj~║        åj║        ªj║        ╞j║        µj    ║        k
  291. ║        &k ║        Fk ║        fk
  292. ║        åk║        ªkH        ≤kÇ║        ,,understands the following transaction types:l~║        3l~║        Sl~║        sl~║        ôl~║        │l║        ╙l║        ≤l║        m    ║        3m
  293. ║        Sm ║        sm ║        ôm
  294. ║        │m║        ╙mH        ≤m~║        n~║        3n~║        Sn~║        sn~║        ôn~║        │n║        ╙n║        ≤n║        o    ║        3o
  295. ║        So ║        so ║        ôo
  296. ║        │o║        ╙oH        p    ÇT        Transaction Type,p    ÇT        Used toLp    ~Æ        lp    ~Æ        îp    ~Æ        ¼p    ~Æ        ╠p    ║        ∞p    D}║         q    ║        ,q        ║        Lq    
  297. ║        lq     ║        îq     ║        ¼q    
  298. ║        ╠q    ║        ∞q    H        r
  299. Ç║        CDepositWr
  300. Ç║        !!Deposit into the Checking accountwr
  301. ~║        ùr
  302. ~║        ╖r
  303. ~║        ╫r
  304. ─}║        ≈r
  305. ║        s
  306. ║        7s
  307. ║        Ws
  308.     ║        ws
  310. ║        ùs
  311. ║        ╖s
  312. ║        ╫s
  314. ║        ≈s
  315. ║        t
  316. H        ;t Ç║        ATMät Ç║        ((ATM withdrawal from the Checking accountñt ~║        ─t ~║        Σt ~║        u ~║        $u ║        Du ║        du ║        äu     ║        ñu
  317. ║        ─u ║        Σu ║        v
  318. ║        $v ║        Dv H        mv Ç║        Transfer┐v Ç║        11Transfer from the Checking to the Savings Account▀v ~║         v ~║        w ~║        ?w ~║        _w Ç║        w ║        ƒw Ç║        ┐w     ║        ▀w
  319. ║         w ║        x ║        ?x
  320. ║        _x ║        x H        ¿x
  321. Ç║        A Number▐x
  322. Ç║        The number of a Check■x
  323. ~║        y
  324. ~║        >y
  325. ~║        ^y
  326. ~║        ~y
  327. ║        ₧y
  328. ║        ╛y
  329. ║        ▐y
  330.     ║        ■y
  332. ║        z
  333. ║        >z
  334. ║        ^z
  336. ║        ~z
  337. ║        ₧z
  338. H        ╟zÇ║        SDeposit{Ç║        Deposit to the Savings Account&{~║        F{~║        f{~║        å{~║        ª{║        ╞{║        µ{║        |    ║        &|
  339. ║        F| ║        f| ║        å|
  340. ║        ª|║        ╞|H        ∩|Ç║        Interest/}Ç║        Interest on the Savings AccountO}~║        o}~║        Å}~║        »}~║        ╧}║        ∩}║        ~║        /~    ║        O~
  341. ║        o~ ║        Å~ ║        »~
  342. ║        ╧~║        ∩~H        ~║        /~║        O~║        o~║        Å~║        »~║        ╧║        ∩║        Ç║        /Ç    ║        OÇ
  343. ║        oÇ ║        ÅÇ ║        »Ç
  344. ║        ╧Ç║        ∩ÇH        ,üÇ╝        Now try it out for yourself!Lü~╗        lü~║        îü~║        ¼ü~║        ╠ü~║        ∞ü║         é║        ,é║        Lé    ║        lé
  345. ║        îé ║        ¼é ║        ╠é
  346. ║        ∞é║         âH        ,â~║        Lâ~╗        lâ~║        îâ~║        ¼â~║        ╠â~║        ∞â║         ä║        ,ä║        Lä    ║        lä
  347. ║        îä ║        ¼ä ║        ╠ä
  348. ║        ∞ä║         àH        =àÇT        Transaction TypebàÇU        Date¥àÇT        Description of Transaction├àÇT        Valueπà~Æ        å~Æ        #å║        Cå║        cå║        âå    ║        úå
  349. ║        ├å ║        πå ║        ç
  350. ║        #ç║        CçH        cç~╜        âç~╛        úç~╜        ├ç~┐        πç~└        ê~║        #ê║        Cê║        cê║        âê    ║        úê
  351. ║        ├ê ║        πê ║        ë
  352. ║        #ë║        CëH        cë~║        âë~║        úë~║        ├ë~║        πë~║        è~║        #è║        Cè║        cè║        âè    ║        úè
  353. ║        ├è ║        πè ║        ï
  354. ║        #ï║        CïH        cï~║        âï~║        ΦïÇ┴        DDClick this button once you have entered the Transaction information:î~║        (î~║        Hî~║        hî║        êî║        ¿î║        ╚î    ║        Φî
  355. ║        ì ║        (ì ║        Hì
  356. ║        hì║        êìH        ¿ì~║        ╚ì~║        Φì~║        Ä~║        (Ä~║        HÄ~║        hÄ║        êÄ║        ¿Ä║        ╚Ä    ║        ΦÄ
  357. ║        Å ║        (Å ║        HÅ
  358. ║        hÅ║        êÅH        ╤ÅÇV        ((Summary Information for the two accounts±Å~ÿ        É~Æ        1É~Æ        QÉ~Æ        qÉ~Æ        æÉ║        ▒É║        ╤É║        ±É    ║        æ
  359. ║        1æ ║        Qæ ║        qæ
  360. ║        ææ║        ▒æH        ╤æ~║        ±æ~╗        Æ~║        1Æ~║        QÆ~║        qÆ~║        æÆ║        ▒Æ║        ╤Æ║        ±Æ    ║        ô
  361. ║        1ô ║        Qô ║        qô
  362. ║        æô║        ▒ôH        ╤ô~║         öÇ┬        Checking Account Balance:SöÇ├$$1CheckingBalance    hë@sö~║        ôö~║        │ö~║        ╙ö║        ≤ö║        ò║        3ò    ║        Sò
  363. ║        sò ║        ôò ║        │ò
  364. ║        ╙ò║        ≤òH        û~║        LûÇ┬        Savings Account Balance:öûÇ├$$1SavingsBalanceA    ╚Æ@┤û~║        ╘û~║        ⌠û~║        ù║        4ù║        Tù║        tù    ║        öù
  365. ║        ┤ù ║        ╘ù ║        ⌠ù
  366. ║        ÿ║        4ÿH        Tÿ║        tÿ~║        öÿ~║        ┤ÿ~║        ╘ÿ~║        ⌠ÿ~║        Ö║        4Ö║        TÖ║        tÖ    ║        öÖ
  367. ║        ┤Ö ║        ╘Ö ║        ⌠Ö
  368. ║        Ü║        4ÜH        TÜ~║        tÜ~║        öÜ~║        ┤Ü~║        ╘Ü~║        ⌠Ü~║        ¢║        4¢║        T¢║        t¢    ║        ö¢
  369. ║        ┤¢ ║        ╘¢ ║        ⌠¢
  370. ║        £║        4£H        T£~║        t£~║        ö£~║        ┤£~║        ╘£~║        ⌠£~║        ¥║        4¥║        T¥║        t¥    ║        ö¥
  371. ║        ┤¥ ║        ╘¥ ║        ⌠¥
  372. ║        ₧║        4₧H        T₧~║        t₧~╗        ö₧~║        ┤₧~║        ╘₧~║        ⌠₧~║        ƒ║        4ƒ║        Tƒ║        tƒ    ║        öƒ
  373. ║        ┤ƒ ║        ╘ƒ ║        ⌠ƒ
  374. ║        á║        4áH        iáÇ─        Checking Account Logëá┼        ⌐á~║        ╔á~║        Θá~║            í~║        )í~║        Ií        ií        ëí            ⌐í
  375.         ╔í         Θí             ó
  376.         )ó        Ió        ió        ëóÇ        ⌐ó        ╔ó~        Θó            ú~⌐        )ú        Iú~        iú        ëú~        ⌐ú        ╔ú~        Θú            ñ            )ñ
  377.         Iñ         iñ         ëñ
  378.         ⌐ñ        ╔ñ        Θñ            Ñ        )Ñ        IÑ        ╦ÑǬ        aaThis page is a simple Checking Account Log.  Take a look at cell F9.  This cell computes the fee δÑ~½         ª~¬        +ª~¬        Kª~¬        kª~¬        ïª~¬        ½ª        ╦ª~        δª             º
  379. ~        +º         Kº ~        kº
  380.         ïº~        ½º        ╦º~        δº         ¿~        +¿        «¿Ç        bbcharged by the bank based on various transaction types. Though you can't see it, the Total Balance╬¿~½        ε¿~¬        ⌐~¬        .⌐~¬        N⌐~¬        n⌐~¬        Ä⌐        «⌐        ╬⌐            ε⌐
  381.         ¬         .¬         N¬
  382.         n¬        Ĭ        «¬        ╬¬        ε¬        ½~        æ½Ç        bbis a labeled cell.  The Checking Account Balance in the Cover Page refers to the name of this cell▒½~½        ╤½~¬        ±½~¬        ¼~¬        1¼~¬        Q¼~¬        q¼~        æ¼        ▒¼    ~        ╤¼
  383.         ±¼         ¡         1¡
  384.         Q¡        q¡        æ¡        ▒¡        ╤¡        ±¡        e«Ç        SSrather than the cell itself, thus allowing you to use a useful name to refer to it.à«~½        Ñ«~¬        ┼«~¬        σ«~¬        »~¬        %»~¬        E»        e»        à»            Ñ»
  385. ~        ┼»         σ» Ç        ░
  386.         %░Ç        E░        e░~        à░        Ñ░~        ┼░        σ░~        ▒~⌐        %▒        E▒        e▒        à▒        Ñ▒        ┼▒        σ▒        ▓            %▓
  387.         E▓         e▓         à▓
  388.         Ñ▓        ┼▓        σ▓        │        %│        E│        v│Ç        Transaction Type¢│Çà        Date╓│Ç        Description of Transaction■│Ç        Deposit)┤Ç        
  390. WithdrawalM┤Ç        Feeu┤Ç        Balanceò┤~        ╡┤        ╒┤    ~        ⌡┤
  391.         ╡ ~        5╡         U╡
  392.         u╡        ò╡        ╡╡        ╒╡        ⌡╡        ╢        >╢Ç        CDepositb╢⌐        πα@æ╢Ç        Opened account╡╢Ç¡         î@╒╢~¡        æ╖Ç¡ÿÿá√ Q ,á√ 
  393. ATM,Φ? ≡?     ╕Ç¡LLú² ñ■ Ñ       î@!╕        A╕        a╕            ü╕
  394.         í╕         ┴╕ ~        ß╕
  395.         ╣~        !╣        A╣~        a╣        ü╣~        í╣        ┼╣    ~«        Y@Θ╣    ~⌐        áπα@║    Ç        Rent.║    ~¡        R║    Ç¡        αu@╗    Ç¡ÿÿ┤√ Q ,┤√ 
  396. ATM,Φ? ≡?     ≡?û╗    Ç¡ddª   ╖² ╕■ ╣      (ü@╢╗            ╓╗            ÷╗                ╝    
  397.         6╝             V╝             v╝    
  398.         û╝            ╢╝            ╓╝            ÷╝            ╜            6╜            Z╜
  399. Ç        ATM~╜
  400. Ç⌐        απα@₧╜
  401.         ╛╜
  402. ~¡        Γ╜
  403. ~¡        i@₧╛
  404. Ç¡ÿÿ╚√ Q ,╚√ 
  405. ATM,Φ? ≡?     Φ?&┐
  406. Ç¡dd║   ╦² ╠■ ═      ─u@F┐
  407. ~        f┐
  408.         å┐
  409.     ~        ª┐
  410. 
  411.         ╞┐
  412.  ~        µ┐
  413.          └
  414. 
  415. ~        &└
  416.         F└
  417.         f└
  418.         å└
  419.         ª└
  420.         ╞└
  421.         Ω└ ~«        @Y@┴ ~⌐        `Σα@9┴ Ç        
  423. Phone BillY┴ ~¡        }┴ ~¡        I@9┬ Ç¡ÿÿ▄√ Q ,▄√ 
  424. ATM,Φ? ≡?     ≡?┴┬ Ç¡dd╬   ▀² α■ ß      ör@ß┬         ├         !├             A├ 
  425.         a├          ü├          í├ 
  426.         ┴├ ~        ß├         ─ ~        !─         A─ ~        a─         à─ ~«        ÇY@⌐─ ~⌐        `Σα@╓─ Ç         Heating Bill÷─ ~¡        ┼ ~¡        D@╓┼ Ç¡ÿÿ≡√ Q ,≡√ 
  427. ATM,Φ? ≡?     ≡?^╞ Ç¡ddΓ   ≤² ⌠■ ⌡      p@~╞         ₧╞         ╛╞             ▐╞ 
  428.         ■╞          ╟          >╟ 
  429.         ^╟         ~╟         ₧╟         ╛╟         ▐╟         ■╟         "╚
  430. ~«        └Y@F╚
  431. ~⌐        `Σα@w╚
  432. Ç        Electricity Billù╚
  433. ~¡        ╗╚
  434. ~¡        4@w╔
  435. Ç¡ÿÿ√ Q ,√ 
  436. ATM,Φ? ≡?     ≡? ╔
  437. Ç¡dd÷   ² ■           hm@╩
  438. ~        ?╩
  439. ~        _╩
  440.     ~        ╩
  441. 
  442. ~        ƒ╩
  443.  ~        ┐╩
  444.  Ç        ▀╩
  445. 
  446. ~         ╩
  447. ~        ╦
  448. ~        ?╦
  449. ~        _╦
  450. ~        ╦
  451. ~        ƒ╦
  452. Ç        ├╦Ç        ATMτ╦~⌐        ÇΣα@╠~        '╠~¡        K╠~¡        └b@═Ç¡ÿÿ√ Q ,√ 
  453. ATM,Φ? ≡?     Φ?Å═Ç¡dd
  454.    ² ■        U@»═~        ╧═~        ∩═    ~        ╬
  455. ~        /╬ ~        O╬ ~        o╬
  456. Ç        Å╬~        »╬~        ╧╬~        ∩╬~        ╧~        /╧~        X╧Ç        CDeposit|╧Ç⌐        └Σα@┤╧Ç        Paycheck-Direct Deposit╪╧~¡        └Æ@°╧~¡        ┤╨Ç¡ÿÿ,√ Q ,,√ 
  457. ATM,Φ? ≡?     <╤Ç¡dd   /² 0■ 1      ö@\╤Ç        |╤Ç        £╤            ╝╤
  458. Ç        ▄╤ Ç        ⁿ╤ ~        ╥
  459. Ç        <╥Ç        \╥~        |╥~        £╥Ç        ╝╥~        ▄╥Ç        ╙Ç        ATM$╙Ç⌐        Çσα@D╙Ç        d╙¡        ê╙Ç¡        @e@D╘Ç¡ÿÿ@√ Q ,@√ 
  460. ATM,Φ? ≡?     Φ?╠╘Ç¡dd2   C² D■ E      gæ@∞╘Ç         ╒~        ,╒    ~        L╒
  461. Ç        l╒ ~        î╒ ~        ¼╒
  462. Ç        ╠╒Ç        ∞╒~         ╓~        ,╓Ç        L╓~        l╓~        ò╓Ç        Transfer╣╓Ç⌐        Çσα@⌡╓Ç        Transfer to Savings Account╫~¡        9╫~¡        i@⌡╫Ç¡ÿÿT√ Q ,T√ 
  463. ATM,Φ? ≡?     }╪Ç¡ddF   W² X■ Y      Äî@¥╪Ç        ╜╪Ç        ▌╪    Ç        ²╪
  464. ~        ┘ ~        =┘ ~        ]┘
  465. Ç        }┘Ç        ¥┘Ç        ╜┘Ç        ▌┘Ç        ²┘~        ┌~        A┌~        ATMe┌~»        τα@à┌~        Ñ┌Ç        ╔┌pv¡        Y@à█Ç¡ÿÿh√ Q ,h√ 
  466. ATM,Φ? ≡?     Φ?
  467. ▄Ç¡ddZ   k² l■ m      hë@-▄Ç        M▄Ç        m▄    Ç        ì▄
  468. Ç        ¡▄ ~        ═▄ ~        φ▄
  469. Ç        
  470. ▌Ç        -▌~        M▌~        m▌~        ì▌v        ¡▌Ç        ═▌Ç        φ▌Ç        
  471. ▐Ç        -▐Ç        M▐■        m▐■        ì▐■        ¡▐■        ═▐■        φ▐    ~        
  472. ▀
  473. ~        -▀ ~        M▀ ~        m▀
  474. ~        ì▀Ç        ¡▀        ═▀~        φ▀~        
  475. α~        -α~        SαÇ        TotalïαÇ⌐φ    ╛ä÷╥╒ß@½α~        ╦αÇ        δα~         ß~        KßÇ¡n■      hë@kß~        ïß~        ½ß    Ç        ╦ß
  476. ~        δß ~         Γ Ç        +Γ
  477. ~        KΓ~        kΓ~        ïΓ~        ½ΓÇ        ╦ΓÇ        δΓÇ         πÇ        +πÇ        KπÇ        kπÇ        ïπÇ        ½π        ╦πÇ        δπÇ         Σ~        +Σ    Ç        KΣ
  478. Ç        kΣ ~        ïΣ ~        ½Σ
  479. Ç        ╦Σ~        δΣÇ         σÇ        +σÇ        Kσ~        kσ~        ïσÇ        ½σ■⌐        ╦σÇ        δσÇ         µÇ        +µÇ        KµÇ        kµÇ        ïµ~        ½µ    ~        ╦µ
  480. ~        δµ ~         τ ~        +τ
  481. ~        Kτ~        kτ~        ïτ~        ½τ~        ╦τ~        δτ~         Φ~        +Φ■⌐        KΦ~        kΦ~        ïΦ~        ½Φ~        ╦Φ~        δΦ~         Θ~        +Θ    ~        KΘ
  482. ~        kΘ ~        ïΘ ~        ½Θ
  483. ~        ╦Θ~        δΘ~         Ω~        +Ω~        KΩ~        kΩ~        ïΩ        ½Ω■⌐        ╦Ω        δΩ         δ        +δ        Kδ        kδ        ïδ        ½δ            ╦δ
  484.         δδ          ∞         +∞
  485.         K∞        k∞        ï∞        ½∞        ╦∞        δ∞         φ        +φ■⌐        Kφ        kφ        ïφ        ½φ        ╦φ        δφ         ε        +ε            Kε
  486.         kε         ïε         ½ε
  487.         ╦ε        δε         ∩        +∩        K∩        k∩        ï∩        ½∩■⌐        ╦∩        δ∩         ≡        +≡        K≡        k≡        ï≡        ½≡            ╦≡
  488.         δ≡          ±         +±
  489.         K±        k±        ï±        ½±        ╦±        δ±         ≥        +≥~⌐        K≥        k≥        ï≥        ½≥        ╦≥        δ≥         ≤        +≤            K≤
  490.         k≤         ï≤         ½≤
  491.         ╦≤        δ≤         ⌠        +⌠        K⌠        k⌠        ï⌠        ½⌠~⌐        ╦⌠        δ⌠         ⌡        +⌡        K⌡        k⌡        ï⌡        ½⌡            ╦⌡
  492.         δ⌡          ÷         +÷
  493.         K÷        k÷        ï÷        ½÷        ╦÷        δ÷         ≈        +≈~⌐        K≈        k≈        ï≈        ½≈        ╦≈        δ≈         °        +°            K°
  494.         k°         ï°         ½°
  495.         ╦°        δ°         ∙        +∙        K∙        k∙        ï∙        ½∙~⌐        ╦∙        δ∙         ·        +·        K·        k·        ï·        ½·            ╦·
  496.         δ·          √         +√
  497.         K√        k√        ï√        ½√        ╦√        δ√         ⁿ        +ⁿ~⌐        Kⁿ        kⁿ        ïⁿ        ½ⁿ        ╦ⁿ        δⁿ         ²        +²            K²
  498.         k²         ï²         ½²
  499.         ╦²        δ²         ■        +■        K■        k■        ƒ■Ç╞        Savings Account Log┐■╗        ▀■~║         ■~║         ~║        ? ~║        _ ╟                 ƒ         ┐             ▀ 
  500.                             ?
  501.         _                ƒ        ┐        ▀                         ?~▓        _                ƒ        ┐~        ▀~¡                         ?            _
  502.                  ƒ         ┐
  503.         ▀                         ?        _                Ǭ        ggThis page is a simple Savings Account Log.  Take a look at cell F9.  This cell computes the fee charged'~▓        G        g        çÇ        º        ╟~¡        τ~        ~        '    ~        G
  504.         g ~        ç ~        º
  505. Ç        ╟~        τ~        Ç        '~        G~        gÇ        ≡Ç        hhby the bank based on various transaction types.  Though you can't see it, the Total Balance is a labeled~▓        0Ç        P~        p~        É~        ░~¡        ╨Ç        ≡Ç            Ç        0
  506. Ç        P Ç        p Ç        É
  507. Ç        ░Ç        ╨        ≡Ç            Ç        0    ~        P    Ç        ┘    Ç        hhcell.  The Checking Account Balance in the Cover Page refers to the name of this cell rather than to the∙    ~▓        
  508. ~        9
  509. Ç        Y
  510. ~        y
  511. Ç        Ö
  512. ~¡        ╣
  513. Ç        ┘
  514. ~        ∙
  515.     ~         
  516. Ç        9  ~        Y  Ç        y 
  517. Ç        Ö Ç        ╣ Ç        ┘ Ç        ∙ Ç         ~        9 ~        ╡ Ç        [[cell itself, allowing you to use a useful name rather than a cell reference to refer to it.╒ ~▓        ⌡ ~        
  518. ~        5
  519. ~        U
  520. ~        u
  521. ~¡        ò
  522. ~        ╡
  523. ~        ╒
  524.     ~        ⌡
  525. 
  526. ~         ~        5 ~        U
  527. ~        u~        ò~        ╡~        ╒~        ⌡~        ~        5~        U~▓        u~        ò~        ╡~        ╒~        ⌡~¡        ~        5~        U    ~        u
  528.         ò         ╡         ╒
  529.         ⌡                5        U        u        ò        ╞Ç        Transaction TypeδÇ:        Date&Ç        Description of TransactionNÇ        DeposityÇ        
  531. Withdrawal¥Ç        Fee┼Ç<        Balanceσ                %            E
  532.         e         à         Ñ
  533.         ┼        σ                %        E        e        ÄÇ        SDeposit▓⌐        πα@ßÇ        Opened accountÇ¡        @Å@%~¡        ßÇ¡ÿÿ √ Q , √ 
  534. ATM,Φ? ≡?     QÇ¡LL#² $■ %      @Å@q        æ        ▒            ╤
  535.         ±                  1
  536.         Q        q        æ        ▒        ╤        ±            ~«        Interest>    ~⌐        └Σα@g    Ç        Interestï    ~¡        @½    Ç¡        g    Ç¡ÿÿ4√ Q ,4√ 
  537. ATM,Φ? ≡?     ∩    Ç¡dd&   7² 8■ 9      PÅ@            /            O                o    
  538.         Å             »             ╧    
  539.         ∩                        /            O            o            Å            ╕
  540. ~«        Transfer▄
  541. ~⌐        Çσα@
  542. Ç        Transfer to Savings Account<
  543. ~¡        i@\
  544. Ç¡        °
  545. Ç¡xxH√ 
  546. Interest,:   {«Gßzö?     Ç
  547. Ç¡dd:   K² L■ M      ╚Æ@á
  548.         └
  549.         α
  550.             
  551. 
  552.          
  553.          @
  554.          `
  555. 
  556.         Ç
  557.         á
  558.         └
  559.         α
  560.         
  561.          
  562.         @         `         Ç         á         └         α                              @          `              Ç  
  563.         á           └           α  
  564.         !          !         @!         `!         Ç!         á!         ╞! Ç        Total■! Ç⌐φ    ╛ä÷╥╒ß@"         >"         ^"         ~"         ╛" Ç¡N■      ╚Æ@▐"         ■"         #             ># 
  565.         ^#          ~#          ₧# 
  566.         ╛#         ▐#         ■#         $         >$         ^$         ~$
  567.         ₧$
  568.         ╛$
  569.         ▐$
  570.         ■$
  571.         %
  572.         >%
  573.         ^%
  574.         ~%
  575.         ₧%
  576.             ╛%
  577. 
  578.         ▐%
  579.          ■%
  580.          &
  581. 
  582.         >&
  583.         ^&
  584.         ~&
  585.         ₧&
  586.         ╛&
  587.         ▐&
  588.         ■&        '        >'        ^'        ~'        ₧'        ╛'        ▐'        ■'        (            >(
  589.         ^(         ~(         ₧(
  590.         ╛(        ▐(        ■(        )        >)        ^)        ~)        ₧)~▓        ╛)        ▐)        ■)        *        >*        ^*        ~*        ₧*            ╛*
  591.         ▐*         ■*         +
  592.         >+        ^+        ~+        ₧+        ╛+        ▐+        ■+        ,~▓        >,        ^,        ~,        ₧,        ╛,        ▐,        ■,        -            >-
  593.         ^-         ~-         ₧-
  594.         ╛-        ▐-        ■-        .        >.        ^.        ~.        ₧.~▓        ╛.        ▐.        ■.        /        >/        ^/        ~/        ₧/            ╛/
  595.         ▐/         ■/         0
  596.         >0        ^0        ~0        ₧0        ╛0        ▐0        ■0        1~▓        >1        ^1        ~1        ₧1        ╛1        ▐1        ■1        2            >2
  597.         ^2         ~2         ₧2
  598.         ╛2        ▐2        ■2        3        >3        ^3        ~3        ₧3~▓        ╛3        ▐3~¡        ■3~¡        4~¡        >4        ^4        ~4        ₧4            ╛4
  599.         ▐4         ■4         5
  600.         >5        ^5        ~5        ₧5        ╛5        ▐5        ■5        6~▓        >6        ^6        ~6        ₧6        ╛6~¡        ▐6        ■6        7            >7
  601.         ^7         ~7         ₧7
  602.         ╛7        ▐7        ■7        8        >8        ^8        ~8        ₧8~▓        ╛8        ▐8        ■8        9        >9~¡        ^9        ~9        ₧9            ╛9
  603.         ▐9         ■9         :
  604.         >:        ^:        ~:        ₧:        ╛:        ▐:        ■:        ;~▓        >;        ^;        ~;        ₧;        ╛;~¡        ▐;        ■;        <            ><
  605.         ^<         ~<         ₧<
  606.         ╛<        ▐<        ■<        =        >=        ^=        ~=        ₧=~▓        ╛=        ▐=        ■=        >        >>~¡        ^>        ~>        ₧>            ╛>
  607.         ▐>         ■>         ?
  608.         >?        ^?        ~?        ₧?        ╛?        ▐?        ■?        @~▓        >@        ^@        ~@        ₧@        ╛@~¡        ▐@        ■@        A            >A
  609.         ^A         ~A         ₧A
  610.         ╛A        ▐A        ■A        B        >B        ^B        ~B        ₧B~▓        ╛B        ▐B        ■B        C        >C~¡        ^C        ~C        ₧C            ╛C
  611.         ▐C         ■C         D
  612.         >D        ^D        ~D        ₧D        ╛D        ▐D        ■D        E~▓        >E        ^E        ~E        ₧E        ╛E~¡        ▐E        ■E        F            >F
  613.         ^F         ~F         ₧F
  614.         ╛F        ▐F        ■F        G        >G        ^G        ~G        ₧G~▓        ╛G        ▐G        ■G        H        >H~¡        ^H        ~H        ₧H            ╛H
  615.         ▐H         ■H         I
  616.         >I        ^I        ~I        ₧I        ╛I        ▐I        ■I        J~▓        >J        ^J        ~J        ₧J        ╛J~¡        ▐J        ■J        K            >K
  617.         ^K         ~K         ₧K
  618.         ╛K        ▐K        ■K        L        >L        ^L        ~L        ₧L~▓        ╛L        ▐L        ■L        M        >M~¡        ^M        ~M        ₧M            ╛M
  619.         ▐M         ■M         N
  620.         >N        ^N        ~N        ₧N        ╛N        ▐N        ■N        O~▓        >O        ^O        ~O        ₧O        ╛O~¡        ▐O        ■O        P            >P
  621.         ^P         ~P         ₧P
  622.         ╛P        ▐P        ■P        Q        >Q        ^Q        ~Q        ₧Q~▓        ╛Q        ▐Q        ■Q        R        >R~¡        ^R        ~R        ₧R            ╛R
  623.         ▐R         ■R         S
  624.         >S        ^S        ~S        ₧S        ╛S        ▐S        µS